home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
farebox.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
889b
|
23 lines
/* RCSVER $Id: farebox.sql,v 1.2 1999-02-24 11:30:32-06 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
*
* Name: farebox.sql
* Date: 12/28/1998
* memo: Randy Wood
* Description: Create the farebox table. This table contains a list of
* all fareboxes defined to the system.
* Changes:
************************************************************************* */
CREATE TABLE farebox
(
glid NUMBER(38) /* Internal sw ID of farebox */
CONSTRAINT ref_farebox1 REFERENCES global_id(glid)
ON DELETE CASCADE,
farebox_id VARCHAR2(20), /* User-defined description */
location NUMBER(38) /* Current location - internal ID */
CONSTRAINT ref_farebox2 REFERENCES global_id(glid)
ON DELETE CASCADE,
CONSTRAINT pk_farebox PRIMARY KEY (glid)
);